// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_MST_MATERIAL_EX
// * CreateDate    : 2014-06-05 18:30:15
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:15
// * LastChanger   : 2014-06-05 18:30:15
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class MstMaterialExTable : TableInfo
    {
		public const string C_TableName = "MST_MATERIAL_EX";
		
		public const string C_MATERIAL_ID = "MATERIAL_ID";
		public const string C_MATERIAL_CODE = "MATERIAL_CODE";
		public const string C_SOURCE = "SOURCE";
		public const string C_LOT_SIZE = "LOT_SIZE";
		public const string C_ORDER_MIN = "ORDER_MIN";
		public const string C_ORDER_MUL = "ORDER_MUL";
		public const string C_LEAD_TIME = "LEAD_TIME";
		public const string C_VLEAD_TIME = "VLEAD_TIME";
		public const string C_SAFE_STOCK = "SAFE_STOCK";
		public const string C_MPS_FLAG = "MPS_FLAG";
		public const string C_PH_FLAG = "PH_FLAG";
		
		public MstMaterialExTable()
        {
            _tableName = "MST_MATERIAL_EX";
        }
		
		protected static MstMaterialExTable _current;
        public static MstMaterialExTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new MstMaterialExTable();

            _current.Add(C_MATERIAL_ID, new ColumnInfo(C_MATERIAL_ID,"MaterialId", true, typeof(string)));
            _current.Add(C_MATERIAL_CODE, new ColumnInfo(C_MATERIAL_CODE,"MaterialCode", false, typeof(string)));
            _current.Add(C_SOURCE, new ColumnInfo(C_SOURCE,"Source", false, typeof(int)));
            _current.Add(C_LOT_SIZE, new ColumnInfo(C_LOT_SIZE,"LotSize", false, typeof(decimal)));
            _current.Add(C_ORDER_MIN, new ColumnInfo(C_ORDER_MIN,"OrderMin", false, typeof(decimal)));
            _current.Add(C_ORDER_MUL, new ColumnInfo(C_ORDER_MUL,"OrderMul", false, typeof(decimal)));
            _current.Add(C_LEAD_TIME, new ColumnInfo(C_LEAD_TIME,"LeadTime", false, typeof(int)));
            _current.Add(C_VLEAD_TIME, new ColumnInfo(C_VLEAD_TIME,"VleadTime", false, typeof(int)));
            _current.Add(C_SAFE_STOCK, new ColumnInfo(C_SAFE_STOCK,"SafeStock", false, typeof(decimal)));
            _current.Add(C_MPS_FLAG, new ColumnInfo(C_MPS_FLAG,"MpsFlag", false, typeof(int)));
            _current.Add(C_PH_FLAG, new ColumnInfo(C_PH_FLAG,"PhFlag", false, typeof(int)));
			
		}
		
		public ColumnInfo MATERIAL_ID
        {
            get { return this[C_MATERIAL_ID]; }
        }
		
		public ColumnInfo MATERIAL_CODE
        {
            get { return this[C_MATERIAL_CODE]; }
        }
		
		public ColumnInfo SOURCE
        {
            get { return this[C_SOURCE]; }
        }
		
		public ColumnInfo LOT_SIZE
        {
            get { return this[C_LOT_SIZE]; }
        }
		
		public ColumnInfo ORDER_MIN
        {
            get { return this[C_ORDER_MIN]; }
        }
		
		public ColumnInfo ORDER_MUL
        {
            get { return this[C_ORDER_MUL]; }
        }
		
		public ColumnInfo LEAD_TIME
        {
            get { return this[C_LEAD_TIME]; }
        }
		
		public ColumnInfo VLEAD_TIME
        {
            get { return this[C_VLEAD_TIME]; }
        }
		
		public ColumnInfo SAFE_STOCK
        {
            get { return this[C_SAFE_STOCK]; }
        }
		
		public ColumnInfo MPS_FLAG
        {
            get { return this[C_MPS_FLAG]; }
        }
		
		public ColumnInfo PH_FLAG
        {
            get { return this[C_PH_FLAG]; }
        }
		
		
		
	}
}

